SQL Database Write

Description

The SQL Database Write tool is a tool that enables the writing of data to a SQL database.

Parent Tools

• SQL Database Config

Settings

Setup Tool

Reference to the SQL Database Config tool.

info

The SQL Database Config tool must be configured before using this tool.

Table Operation

The table operation to perform on the SQL database. The following table operations are available:

• Custom command: Custom SQL query.
• INSERT: Insert a row into the table.
• UPDATE: Update a row in the table.

Table Name

The name of the table to perform the table operation on.

Query String

Custom command

The SQL query to execute on the SQL database.

This input supports Mark-up Text Input.

Row Map

INSERT

A map containing column name (key) and row value (value), for INSERT.

The value input supports Mark-up Text Input.

Row Map example

Key	Value
col1	val1
col2	val2

This will be represented as:

INSERT INTO table_name (col1, col2) VALUES (val1, val2);

Where Map

UPDATE

A map containing column name (key) and row value (value), for WHERE.

The value input supports Mark-up Text Input.

Where Map example

Key	Value
whereA	a
whereB	b

This will be represented as:

UPDATE table_name SET col1 = val1, col2 = val2 WHERE whereA = a AND whereB = b;

Set Map

UPDATE

A map containing column name (key) and row value (value), for UPDATE.

The value input supports Mark-up Text Input.

Set Map example

Key	Value
setA	a
setB	b

This will be represented as:

UPDATE table_name SET setA = a, setB = b WHERE col1 = val1 AND col2 = val2;